Stored Procedures [dbo].[BAEBillingMemberTypes]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEBillingMemberTypes
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@UserIDvarchar(10)10
SQL Script
/*
    This procedure returns all of the member types that will be available for the user to select from.

    NOTE:

    You MUST return at least 1 record with the columns MEMBER_TYPE and DESCRIPTION.
*/
CREATE PROCEDURE [dbo].[BAEBillingMemberTypes]
    @UserID as varchar(10)
AS
    SELECT MEMBER_TYPE, DESCRIPTION FROM Member_Types;


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved